package RepaymentPlan;

/**
 * @author yunfei.shang
 * @title
 * @date 2018/12/10 17:37
 * @descreption
 */
public class BuildAddColumeSql {
    public static void main(String[] args) {
        String sql =
                "ALTER TABLE project_overdue_daily_%03d ADD COLUMN `CalRealStartDate` date NOT NULL DEFAULT '1900-01-01' COMMENT '实际计算起始日期' AFTER `CalStartDate`;";
        for (int i = 0;
             i < 128; i++) {
            System.out.println(String.format(sql, i, i));
        }
    }
}
